package com.shzu.jwc.ty.dao;

import com.shzu.jwc.ty.bean.TheoreticalExaminationAppointment;
import com.shzu.jwc.ty.bean.TheoreticalExaminationAppointmentExample;
import java.util.List;
import org.apache.ibatis.annotations.Param;

public interface TheoreticalExaminationAppointmentMapper {
    long countByExample(TheoreticalExaminationAppointmentExample example);

    int deleteByExample(TheoreticalExaminationAppointmentExample example);

    int deleteByPrimaryKey(Integer theoreticalExaminationAppointmentId);

    int insert(TheoreticalExaminationAppointment record);

    int insertSelective(TheoreticalExaminationAppointment record);

    List<TheoreticalExaminationAppointment> selectByExample(TheoreticalExaminationAppointmentExample example);

    TheoreticalExaminationAppointment selectByPrimaryKey(Integer theoreticalExaminationAppointmentId);

    int updateByExampleSelective(@Param("record") TheoreticalExaminationAppointment record, @Param("example") TheoreticalExaminationAppointmentExample example);

    int updateByExample(@Param("record") TheoreticalExaminationAppointment record, @Param("example") TheoreticalExaminationAppointmentExample example);

    int updateByPrimaryKeySelective(TheoreticalExaminationAppointment record);

    int updateByPrimaryKey(TheoreticalExaminationAppointment record);

    List<TheoreticalExaminationAppointment> getTheoreticalExaminationscore(@Param("systemYearId") Integer systemYearId, @Param("startPos") Integer startPos, @Param("pageSize") Integer pageSize);

    long countTheoreticalExaminationscore(@Param("systemYearId") Integer systemYearId);

    List<TheoreticalExaminationAppointment> selectTheoreticalExaminationscore(@Param("systemYearId") Integer systemYearId, @Param("theoreticalExaminationId") Integer theoreticalExaminationId, @Param("startPos") Integer startPos, @Param("pageSize") Integer pageSize);

    long countselectTheoreticalExaminationscore(@Param("systemYearId") Integer systemYearId, @Param("theoreticalExaminationId") Integer theoreticalExaminationId);

    List<TheoreticalExaminationAppointment> upselectTheoreticalExaminationscore(@Param("systemYearId") Integer systemYearId, @Param("userStudentInfoYear") Integer userStudentInfoYear, @Param("userStudentInfoCollege") String userStudentInfoCollege, @Param("theoreticalExaminationId") Integer theoreticalExaminationId);

    Integer updatescore(@Param("theoreticalExaminationAppointmentScore") Double theoreticalExaminationAppointmentScore, @Param("theoreticalExaminationAppointmentId") Integer theoreticalExaminationAppointmentId);

    Integer updatenormalscore(@Param("theoreticalExaminationNormalscore") Double theoreticalExaminationNormalscore, @Param("theoreticalExaminationAppointmentId") Integer theoreticalExaminationAppointmentId);

    Integer updatemidscore(@Param("theoreticalExaminationMidscore") Double theoreticalExaminationMidscore, @Param("theoreticalExaminationAppointmentId") Integer theoreticalExaminationAppointmentId);

    Integer updatetotalscore(@Param("theoreticalExaminationTotalscore") Double theoreticalExaminationTotalscore, @Param("theoreticalExaminationAppointmentId") Integer theoreticalExaminationAppointmentId);

    List<TheoreticalExaminationAppointment> getData(@Param("systemYearId") Integer systemYearId, @Param("theoreticalExaminationAppointmentScore") Double theoreticalExaminationAppointmentScore,@Param("theoreticalExaminationId") Integer theoreticalExaminationId,@Param("userStudentInfoNum") String userStudentInfoNum);

}